<?php
	$query = 'select * from locations order by name';

	$count = $database->numrows($query);
	$results = $database->query($query);

	$smarty->assign('results',results);
	$smarty->assign('number_locations',$count);
?>